FO_Hub_Job_Def_Detail

This table contains the specific Client/Provider/PtLocations to be included on job run when selecting data from tables to use for this job.

 

Field Type Notes

Hub_Job_Def_Detail_ID

int

ID field, a counter. Unique

HubCode

varchar(50)

Code for HUB

JobID

varchar(50)

Enter a unique ID for job.

Recommended to establish a naming convention as this will assist in readily identifying jobs.

ClientCode

varchar(50)

Defines a list of client codes.

Multidimensional pipe delimited field, with leading and trailing pipes.

Enter valid client codes separated by pipes.

ProviderCode

varchar(50)

Defines a list of provider codes.

Multidimensional pipe delimited field, with leading and trailing pipes.

Enter valid provider codes separated by pipes.

PtLocationCode

varchar(50)

Defines a list of PTLoc, patient location, codes.

Multidimensional pipe delimited field, with leading and trailing pipes.

Enter valid PTLoc codes separated by pipes.

CreateDate

datetime

Date record was created.

Informational

EditDate

datetime

Date record was last edited.

Informational

CreateUser

varchar(50)

User who created record.

Informational

EditUser

varchar(50)

User who last edited record.

Informational